﻿CREATE TABLE [dbo].[UDS_Bbs_ForumItem] (
    [item_id]          int           NOT NULL identity(1, 1),
    [board_id]         int           NULL,
    [title]            nvarchar(300)  COLLATE Chinese_PRC_CI_AS NULL,
    [content]          nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
    [sender]           nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [send_time]        datetime      NULL,
    [hit_times]        int           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_hit_times] default(((0))),
    [replay_times]     int           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_replay_times] default(((0))),
    [last_replayer]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [last_replay_time] datetime      NULL,
    [ip]               nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [bulletin]         bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_bulletin] default(((0))),
    [sysbulletin]      bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_sysbulletin] default(((0))),
    [desktop]          bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_desktop] default(((0))),

    CONSTRAINT [PK_uds_bbs_forumItem] PRIMARY KEY CLUSTERED ([item_id] asc)
);
GO
